OpenEdge Data Management:<br />DataServer for ORACLE Updating a schema image

In this exercise, you update a schema image to reflect any changes you might have made to the data definitions for your ORACLE database.

Add additional object definitions from the ORACLE database to a schema image. Use this option if you add a new table or view to the ORACLE data definition and want that change reflected in the schema image.

Update existing object definitions in a schema image to reflect a change in the supporting ORACLE database object definitions.

Choose DataServer

ORACLE Utilities

Update/Add Table Definitions. The utility will ask you to verify that you are connected with a User ID and Password combination that has sufficient privileges. If the current User ID is correct, click OK, otherwise enter a different User ID and Password combination.

Once you are properly connected to ORACLE, the following dialog box appears:

Preselect the ORACLE objects that the utility uses to update the schema image. By default, the wild card symbol (*) appears in the fill-in fields. The wild cards specify that the utility will use all objects in the ORACLE database, including system catalog information. You can change the criteria by typing new information in the fill-in fields.

Note: If there are links to Distributed Databases in your ORACLE instance, a list of them will be displayed. Either highlight the proper link, or simply click OK.

Choose OK. A dialog box lists the objects and table information that you preselected:

Select the objects you want to update, then choose OK. Typically, you should not include system-owned objects.

To select tables by matching a pattern, choose the Select Some button. The following dialog box appears:

Type the pattern that you want to match, then choose OK. The application returns to the main window.

When you update a definition, the old definition is overwritten with the new one based on the current ORACLE object. It also preserves the Progress-specific table information. So, if you want to add a new column to a table in your ORACLE database and then update the definition, you do not have to re-enter all of the Progress-specific information for the previously existing columns (fields) in the definition.